Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 291 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 58.8 KiB |
| Average record size in memory | 206.8 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 5 |
| DateTime | 1 |
mine has constant value "1" | Constant |
machine has constant value "1" | Constant |
operator has constant value "1" | Constant |
distance_travelled is highly overall correlated with engine_hours and 6 other fields | High correlation |
engine_hours is highly overall correlated with distance_travelled and 6 other fields | High correlation |
fuel_consumed is highly overall correlated with distance_travelled and 6 other fields | High correlation |
idle_hours is highly overall correlated with distance_travelled and 6 other fields | High correlation |
no_of_loads is highly overall correlated with distance_travelled and 6 other fields | High correlation |
operating_hours is highly overall correlated with distance_travelled and 6 other fields | High correlation |
tonnage is highly overall correlated with distance_travelled and 6 other fields | High correlation |
transmission_hours is highly overall correlated with distance_travelled and 6 other fields | High correlation |
id has unique values | Unique |
distance_travelled has 20 (6.9%) zeros | Zeros |
tonnage has 79 (27.1%) zeros | Zeros |
fuel_consumed has 20 (6.9%) zeros | Zeros |
no_of_loads has 79 (27.1%) zeros | Zeros |
operating_hours has 54 (18.6%) zeros | Zeros |
engine_hours has 99 (34.0%) zeros | Zeros |
transmission_hours has 99 (34.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-12 10:03:00.394978 |
|---|---|
| Analysis finished | 2025-02-12 10:03:04.894316 |
| Duration | 4.5 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
id
Real number (ℝ)
Unique
| Distinct | 291 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 285.04467 |
| Minimum | 1 |
|---|---|
| Maximum | 763 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 15.5 |
| Q1 | 73.5 |
| median | 146 |
| Q3 | 635 |
| 95-th percentile | 741.5 |
| Maximum | 763 |
| Range | 762 |
| Interquartile range (IQR) | 561.5 |
Descriptive statistics
| Standard deviation | 279.43492 |
|---|---|
| Coefficient of variation (CV) | 0.98031976 |
| Kurtosis | -1.2844964 |
| Mean | 285.04467 |
| Median Absolute Deviation (MAD) | 91 |
| Skewness | 0.7450551 |
| Sum | 82948 |
| Variance | 78083.877 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 763 | 1 | 0.3% |
| 1 | 1 | 0.3% |
| 2 | 1 | 0.3% |
| 739 | 1 | 0.3% |
| 738 | 1 | 0.3% |
| 736 | 1 | 0.3% |
| 735 | 1 | 0.3% |
| 733 | 1 | 0.3% |
| 732 | 1 | 0.3% |
| 730 | 1 | 0.3% |
| Other values (281) | 281 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 763 | 1 | |
| 762 | 1 | |
| 760 | 1 | |
| 759 | 1 | |
| 757 | 1 | |
| 756 | 1 | |
| 754 | 1 | |
| 753 | 1 | |
| 751 | 1 | |
| 750 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 2 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 147 | |
| 2 | 144 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 147 | |
| 2 | 144 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 147 | |
| 2 | 144 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 147 | |
| 2 | 144 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 147 | |
| 2 | 144 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 147 | |
| 2 | 144 |
date
Date
| Distinct | 149 |
|---|---|
| Distinct (%) | 51.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 KiB |
| Minimum | 2018-12-15 00:00:00 |
|---|---|
| Maximum | 2024-12-11 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
distance_travelled
Real number (ℝ)
High correlation Zeros
| Distinct | 21 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.594502 |
| Minimum | 0 |
|---|---|
| Maximum | 235 |
| Zeros | 20 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 9 |
| Q3 | 14 |
| 95-th percentile | 19 |
| Maximum | 235 |
| Range | 235 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 30.025056 |
|---|---|
| Coefficient of variation (CV) | 2.3839812 |
| Kurtosis | 49.96622 |
| Mean | 12.594502 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 7.0399236 |
| Sum | 3665 |
| Variance | 901.50397 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 3 | 25 | 8.6% |
| 12 | 23 | 7.9% |
| 1 | 21 | 7.2% |
| 6 | 20 | 6.9% |
| 0 | 20 | 6.9% |
| 15 | 18 | 6.2% |
| 9 | 16 | 5.5% |
| 13 | 16 | 5.5% |
| 2 | 13 | 4.5% |
| 16 | 12 | 4.1% |
| Other values (11) | 107 |
| Value | Count | Frequency (%) |
| 0 | 20 | |
| 1 | 21 | |
| 2 | 13 | |
| 3 | 25 | |
| 4 | 11 | |
| 5 | 9 | 3.1% |
| 6 | 20 | |
| 7 | 12 | |
| 8 | 10 | 3.4% |
| 9 | 16 |
| Value | Count | Frequency (%) |
| 235 | 5 | 1.7% |
| 19 | 11 | |
| 18 | 11 | |
| 17 | 12 | |
| 16 | 12 | |
| 15 | 18 | |
| 14 | 6 | 2.1% |
| 13 | 16 | |
| 12 | 23 | |
| 11 | 10 |
tonnage
Real number (ℝ)
High correlation Zeros
| Distinct | 33 |
|---|---|
| Distinct (%) | 11.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 130.88316 |
| Minimum | 0 |
|---|---|
| Maximum | 329 |
| Zeros | 79 |
| Zeros (%) | 27.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 132 |
| Q3 | 222 |
| 95-th percentile | 294 |
| Maximum | 329 |
| Range | 329 |
| Interquartile range (IQR) | 222 |
Descriptive statistics
| Standard deviation | 102.52129 |
|---|---|
| Coefficient of variation (CV) | 0.78330386 |
| Kurtosis | -1.2433303 |
| Mean | 130.88316 |
| Median Absolute Deviation (MAD) | 92 |
| Skewness | 0.085174626 |
| Sum | 38087 |
| Variance | 10510.614 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 180 | 17 | 5.8% |
| 90 | 12 | 4.1% |
| 222 | 10 | 3.4% |
| 154 | 9 | 3.1% |
| 210 | 9 | 3.1% |
| 224 | 9 | 3.1% |
| 70 | 8 | 2.7% |
| 105 | 8 | 2.7% |
| 119 | 8 | 2.7% |
| Other values (23) | 122 |
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 34 | 5 | 1.7% |
| 60 | 3 | 1.0% |
| 70 | 8 | 2.7% |
| 72 | 5 | 1.7% |
| 84 | 4 | 1.4% |
| 90 | 12 | 4.1% |
| 102 | 4 | 1.4% |
| 105 | 8 | 2.7% |
| 119 | 8 | 2.7% |
| Value | Count | Frequency (%) |
| 329 | 4 | |
| 315 | 7 | |
| 294 | 5 | |
| 282 | 7 | |
| 280 | 4 | |
| 270 | 4 | |
| 259 | 8 | |
| 252 | 7 | |
| 245 | 3 | 1.0% |
| 240 | 8 |
fuel_consumed
Real number (ℝ)
High correlation Zeros
| Distinct | 51 |
|---|---|
| Distinct (%) | 17.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.924399 |
| Minimum | 0 |
|---|---|
| Maximum | 200 |
| Zeros | 20 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 30 |
| median | 80 |
| Q3 | 120 |
| 95-th percentile | 171 |
| Maximum | 200 |
| Range | 200 |
| Interquartile range (IQR) | 90 |
Descriptive statistics
| Standard deviation | 54.662423 |
|---|---|
| Coefficient of variation (CV) | 0.68392661 |
| Kurtosis | -1.0168801 |
| Mean | 79.924399 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 0.23267782 |
| Sum | 23258 |
| Variance | 2987.9805 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 20 | 6.9% |
| 120 | 16 | 5.5% |
| 90 | 13 | 4.5% |
| 30 | 12 | 4.1% |
| 72 | 9 | 3.1% |
| 60 | 8 | 2.7% |
| 144 | 8 | 2.7% |
| 108 | 8 | 2.7% |
| 160 | 7 | 2.4% |
| 8 | 7 | 2.4% |
| Other values (41) | 183 |
| Value | Count | Frequency (%) |
| 0 | 20 | |
| 8 | 7 | 2.4% |
| 9 | 7 | 2.4% |
| 10 | 7 | 2.4% |
| 16 | 3 | 1.0% |
| 18 | 5 | 1.7% |
| 20 | 5 | 1.7% |
| 24 | 7 | 2.4% |
| 27 | 6 | 2.1% |
| 30 | 12 |
| Value | Count | Frequency (%) |
| 200 | 5 | |
| 190 | 2 | 0.7% |
| 180 | 6 | |
| 171 | 3 | 1.0% |
| 170 | 1 | 0.3% |
| 160 | 7 | |
| 153 | 6 | |
| 152 | 6 | |
| 150 | 6 | |
| 144 | 8 |
no_of_loads
Real number (ℝ)
High correlation Zeros
| Distinct | 17 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.508591 |
| Minimum | 0 |
|---|---|
| Maximum | 47 |
| Zeros | 79 |
| Zeros (%) | 27.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 32 |
| 95-th percentile | 45 |
| Maximum | 47 |
| Range | 47 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 15.67677 |
|---|---|
| Coefficient of variation (CV) | 0.76440017 |
| Kurtosis | -1.2869063 |
| Mean | 20.508591 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 0.015402403 |
| Sum | 5968 |
| Variance | 245.76113 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 30 | 23 | 7.9% |
| 15 | 20 | 6.9% |
| 37 | 18 | 6.2% |
| 32 | 16 | 5.5% |
| 22 | 16 | 5.5% |
| 20 | 15 | 5.2% |
| 42 | 12 | 4.1% |
| 40 | 12 | 4.1% |
| 17 | 12 | 4.1% |
| Other values (7) | 68 |
| Value | Count | Frequency (%) |
| 0 | 79 | |
| 10 | 11 | 3.8% |
| 12 | 9 | 3.1% |
| 15 | 20 | 6.9% |
| 17 | 12 | 4.1% |
| 20 | 15 | 5.2% |
| 22 | 16 | 5.5% |
| 25 | 10 | 3.4% |
| 27 | 10 | 3.4% |
| 30 | 23 | 7.9% |
| Value | Count | Frequency (%) |
| 47 | 11 | |
| 45 | 11 | |
| 42 | 12 | |
| 40 | 12 | |
| 37 | 18 | |
| 35 | 6 | 2.1% |
| 32 | 16 | |
| 30 | 23 | |
| 27 | 10 | |
| 25 | 10 |
operating_hours
Real number (ℝ)
High correlation Zeros
| Distinct | 8 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.1237113 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 54 |
| Zeros (%) | 18.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 4.0512009 |
|---|---|
| Coefficient of variation (CV) | 1.2969191 |
| Kurtosis | 31.171272 |
| Mean | 3.1237113 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.0008477 |
| Sum | 909 |
| Variance | 16.412229 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 0 | 54 | |
| 1 | 45 | |
| 4 | 45 | |
| 2 | 42 | |
| 5 | 42 | |
| 3 | 36 | |
| 6 | 22 | |
| 30 | 5 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 54 | |
| 1 | 45 | |
| 2 | 42 | |
| 3 | 36 | |
| 4 | 45 | |
| 5 | 42 | |
| 6 | 22 | |
| 30 | 5 | 1.7% |
| Value | Count | Frequency (%) |
| 30 | 5 | 1.7% |
| 6 | 22 | |
| 5 | 42 | |
| 4 | 45 | |
| 3 | 36 | |
| 2 | 42 | |
| 1 | 45 | |
| 0 | 54 |
idle_hours
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 14.3 KiB |
| 0 | |
|---|---|
| 1 | |
| 34 | 5 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0171821 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 177 | |
| 1 | 109 | |
| 34 | 5 | 1.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 177 | |
| 1 | 109 | |
| 34 | 5 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 177 | |
| 1 | 109 | |
| 3 | 5 | 1.7% |
| 4 | 5 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 296 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177 | |
| 1 | 109 | |
| 3 | 5 | 1.7% |
| 4 | 5 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 296 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177 | |
| 1 | 109 | |
| 3 | 5 | 1.7% |
| 4 | 5 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 296 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 177 | |
| 1 | 109 | |
| 3 | 5 | 1.7% |
| 4 | 5 | 1.7% |
engine_hours
Real number (ℝ)
High correlation Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4501718 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 99 |
| Zeros (%) | 34.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 6.4524862 |
|---|---|
| Coefficient of variation (CV) | 2.6334831 |
| Kurtosis | 48.885893 |
| Mean | 2.4501718 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 6.9282939 |
| Sum | 713 |
| Variance | 41.634578 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 99 | |
| 3 | 87 | |
| 1 | 42 | |
| 2 | 36 | 12.4% |
| 4 | 22 | 7.6% |
| 50 | 5 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 99 | |
| 1 | 42 | |
| 2 | 36 | 12.4% |
| 3 | 87 | |
| 4 | 22 | 7.6% |
| 50 | 5 | 1.7% |
| Value | Count | Frequency (%) |
| 50 | 5 | 1.7% |
| 4 | 22 | 7.6% |
| 3 | 87 | |
| 2 | 36 | 12.4% |
| 1 | 42 | |
| 0 | 99 |
transmission_hours
Real number (ℝ)
High correlation Zeros
| Distinct | 6 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0206186 |
| Minimum | 0 |
|---|---|
| Maximum | 25 |
| Zeros | 99 |
| Zeros (%) | 34.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 25 |
| Range | 25 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.3517244 |
|---|---|
| Coefficient of variation (CV) | 1.6587615 |
| Kurtosis | 35.917649 |
| Mean | 2.0206186 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 5.5385428 |
| Sum | 588 |
| Variance | 11.234056 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 99 | |
| 3 | 87 | |
| 1 | 42 | |
| 2 | 36 | 12.4% |
| 4 | 22 | 7.6% |
| 25 | 5 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 99 | |
| 1 | 42 | |
| 2 | 36 | 12.4% |
| 3 | 87 | |
| 4 | 22 | 7.6% |
| 25 | 5 | 1.7% |
| Value | Count | Frequency (%) |
| 25 | 5 | 1.7% |
| 4 | 22 | 7.6% |
| 3 | 87 | |
| 2 | 36 | 12.4% |
| 1 | 42 | |
| 0 | 99 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 291 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 291 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 291 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 291 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 291 |
Interactions
Correlations
| distance_travelled | engine_hours | fuel_consumed | id | idle_hours | no_of_loads | operating_hours | shift_number | tonnage | transmission_hours | |
|---|---|---|---|---|---|---|---|---|---|---|
| distance_travelled | 1.000 | 0.965 | 0.989 | 0.017 | 0.998 | 0.962 | 0.991 | 0.000 | 0.930 | 0.965 |
| engine_hours | 0.965 | 1.000 | 0.956 | 0.057 | 0.998 | 0.944 | 0.974 | 0.000 | 0.910 | 1.000 |
| fuel_consumed | 0.989 | 0.956 | 1.000 | 0.027 | 0.881 | 0.951 | 0.982 | 0.000 | 0.917 | 0.956 |
| id | 0.017 | 0.057 | 0.027 | 1.000 | 0.462 | 0.014 | 0.027 | 0.000 | 0.003 | 0.057 |
| idle_hours | 0.998 | 0.998 | 0.881 | 0.462 | 1.000 | 0.738 | 1.000 | 0.021 | 0.946 | 1.000 |
| no_of_loads | 0.962 | 0.944 | 0.951 | 0.014 | 0.738 | 1.000 | 0.954 | 0.000 | 0.989 | 0.944 |
| operating_hours | 0.991 | 0.974 | 0.982 | 0.027 | 1.000 | 0.954 | 1.000 | 0.021 | 0.921 | 0.974 |
| shift_number | 0.000 | 0.000 | 0.000 | 0.000 | 0.021 | 0.000 | 0.021 | 1.000 | 0.000 | 0.021 |
| tonnage | 0.930 | 0.910 | 0.917 | 0.003 | 0.946 | 0.989 | 0.921 | 0.000 | 1.000 | 0.910 |
| transmission_hours | 0.965 | 1.000 | 0.956 | 0.057 | 1.000 | 0.944 | 0.974 | 0.021 | 0.910 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| id | shift_number | date | distance_travelled | tonnage | fuel_consumed | no_of_loads | operating_hours | idle_hours | engine_hours | transmission_hours | mine | machine | operator | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2 | 2024-01-01 | 5 | 72 | 45 | 12 | 1 | 0 | 0 | 0 | 1 | 1 | 1 |
| 1 | 2 | 1 | 2024-01-02 | 8 | 120 | 64 | 20 | 2 | 0 | 1 | 1 | 1 | 1 | 1 |
| 2 | 3 | 2 | 2024-01-02 | 19 | 282 | 152 | 47 | 6 | 1 | 4 | 4 | 1 | 1 | 1 |
| 3 | 4 | 1 | 2024-01-03 | 19 | 282 | 190 | 47 | 6 | 1 | 4 | 4 | 1 | 1 | 1 |
| 4 | 5 | 2 | 2024-01-03 | 2 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
| 5 | 6 | 1 | 2024-01-04 | 12 | 210 | 120 | 30 | 4 | 1 | 3 | 3 | 1 | 1 | 1 |
| 6 | 7 | 2 | 2024-01-04 | 12 | 210 | 96 | 30 | 4 | 1 | 3 | 3 | 1 | 1 | 1 |
| 7 | 8 | 1 | 2024-01-05 | 5 | 72 | 45 | 12 | 1 | 0 | 0 | 0 | 1 | 1 | 1 |
| 8 | 9 | 2 | 2024-01-05 | 16 | 280 | 160 | 40 | 5 | 1 | 3 | 3 | 1 | 1 | 1 |
| 9 | 10 | 1 | 2024-01-06 | 18 | 270 | 144 | 45 | 6 | 1 | 4 | 4 | 1 | 1 | 1 |
| id | shift_number | date | distance_travelled | tonnage | fuel_consumed | no_of_loads | operating_hours | idle_hours | engine_hours | transmission_hours | mine | machine | operator | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281 | 750 | 2 | 2024-12-07 | 3 | 0 | 24 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 |
| 282 | 751 | 1 | 2024-12-07 | 13 | 224 | 104 | 32 | 4 | 1 | 3 | 3 | 1 | 1 | 1 |
| 283 | 753 | 1 | 2024-12-08 | 10 | 150 | 100 | 25 | 3 | 0 | 2 | 2 | 1 | 1 | 1 |
| 284 | 754 | 2 | 2024-12-08 | 15 | 259 | 150 | 37 | 5 | 1 | 3 | 3 | 1 | 1 | 1 |
| 285 | 756 | 2 | 2024-12-09 | 1 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
| 286 | 757 | 1 | 2024-12-09 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
| 287 | 759 | 1 | 2024-12-10 | 12 | 180 | 120 | 30 | 4 | 1 | 3 | 3 | 1 | 1 | 1 |
| 288 | 760 | 2 | 2024-12-10 | 14 | 210 | 112 | 35 | 4 | 1 | 3 | 3 | 1 | 1 | 1 |
| 289 | 762 | 2 | 2024-12-11 | 15 | 222 | 120 | 37 | 5 | 1 | 3 | 3 | 1 | 1 | 1 |
| 290 | 763 | 1 | 2024-12-11 | 16 | 240 | 128 | 40 | 5 | 1 | 3 | 3 | 1 | 1 | 1 |